1 Neighbourhood boundaries

1.1 BCC suburbs

Full (?) list of Brisbane suburbs. Top 5 alphabetically:

SSC_NAME16
Acacia Ridge
Albion
Alderley
Algester
Annerley

This might very well include areas with no pops (and therefore no SEIFA), for instance:

SSC_NAME16
Brisbane Airport
Port Of Brisbane

1.2 ABS

Names from Brisbane containing (Brisbane - Qld), names from Qld containing (Qld) have to cleaned to match BCC data.

McDowall is called McDowall and Mount Coot-tha is Mount Coot-Tha.

Areas without matches using original names

SSC_NAME16 SSC_CODE16 SSC_NAME16_orig
Albion 30024 Albion (Brisbane - Qld)
Ascot 30089 Ascot (Brisbane - Qld)
Bald Hills 30123 Bald Hills (Qld)
Balmoral 30132 Balmoral (Qld)
Belmont 30226 Belmont (Qld)
Brighton 30375 Brighton (Qld)
Brookfield 30388 Brookfield (Qld)
Carina 30542 Carina (Qld)
Chandler 30583 Chandler (Qld)
Chapel Hill 30584 Chapel Hill (Qld)
Durack 30913 Durack (Qld)
Fairfield 31025 Fairfield (Qld)
Grange 31236 Grange (Qld)
Hamilton 31301 Hamilton (Qld)
Jindalee 31459 Jindalee (Qld)
Kangaroo Point 31496 Kangaroo Point (Qld)
Kooringal 31586 Kooringal (Qld)
Larapinta 31654 Larapinta (Qld)
Macgregor 31736 Macgregor (Qld)
Mackenzie 31741 Mackenzie (Brisbane - Qld)
Manly 31764 Manly (Qld)
Mansfield 31768 Mansfield (Qld)
Mcdowall 31806 McDowall
Middle Park 31839 Middle Park (Qld)
Milton 31864 Milton (Qld)
Mount Coot-Tha 31969 Mount Coot-tha
Newstead 32156 Newstead (Qld)
Northgate 32207 Northgate (Qld)
Oxley 32262 Oxley (Qld)
Paddington 32269 Paddington (Qld)
Red Hill 32424 Red Hill (Brisbane - Qld)
Richlands 32447 Richlands (Qld)
Robertson 32467 Robertson (Qld)
Rocklea 32474 Rocklea (Qld)
Salisbury 32527 Salisbury (Qld)
Sandgate 32532 Sandgate (Qld)
Seven Hills 32562 Seven Hills (Qld)
Sherwood 32579 Sherwood (Qld)
Spring Hill 32648 Spring Hill (Qld)
Tennyson 32798 Tennyson (Qld)
The Gap 32817 The Gap (Brisbane - Qld)
Virginia 32981 Virginia (Qld)
West End 33063 West End (Brisbane - Qld)
Windsor 33126 Windsor (Qld)
Wishart 33132 Wishart (Qld)

Stones Corner doesn’t exist in ABS but it does in BCC. It seems it’s part of Greenslopes.

## # A tibble: 1 x 3
##   SSC_NAME16    SSC_CODE16 SSC_NAME16_orig
##   <chr>              <int> <chr>          
## 1 Stones Corner         NA <NA>

Full map

2 SEIFA

2.1 Coverage

Data for Australia, example of IRSD.

## 
## x <integer>
## # total N=13713  valid N=13691  mean=5.50  sd=2.87
## 
## Value |    N | Raw % | Valid % | Cum. %
## ---------------------------------------
##     1 | 1369 |  9.98 |   10.00 |  10.00
##     2 | 1369 |  9.98 |   10.00 |  20.00
##     3 | 1370 |  9.99 |   10.01 |  30.01
##     4 | 1370 |  9.99 |   10.01 |  40.01
##     5 | 1367 |  9.97 |    9.98 |  50.00
##     6 | 1370 |  9.99 |   10.01 |  60.00
##     7 | 1369 |  9.98 |   10.00 |  70.00
##     8 | 1369 |  9.98 |   10.00 |  80.00
##     9 | 1371 | 10.00 |   10.01 |  90.02
##    10 | 1367 |  9.97 |    9.98 | 100.00
##  <NA> |   22 |  0.16 |    <NA> |   <NA>

Brisbane suburbs only

## 
## x <integer>
## # total N=193  valid N=184  mean=7.79  sd=2.37
## 
## Value |  N | Raw % | Valid % | Cum. %
## -------------------------------------
##     1 |  3 |  1.55 |    1.63 |   1.63
##     2 |  6 |  3.11 |    3.26 |   4.89
##     3 |  5 |  2.59 |    2.72 |   7.61
##     4 |  5 |  2.59 |    2.72 |  10.33
##     5 | 13 |  6.74 |    7.07 |  17.39
##     6 | 12 |  6.22 |    6.52 |  23.91
##     7 | 28 | 14.51 |   15.22 |  39.13
##     8 | 18 |  9.33 |    9.78 |  48.91
##     9 | 33 | 17.10 |   17.93 |  66.85
##    10 | 61 | 31.61 |   33.15 | 100.00
##  <NA> |  9 |  4.66 |    <NA> |   <NA>

2.2 Missing

Few areas with missing SEIFA

##           SSC_NAME16 IRSD_d IRSAD_d IER_d IEO_d URP
## 1        Banks Creek     NA      NA    NA    NA  NA
## 2   Brisbane Airport     NA      NA    NA    NA  NA
## 3         Eagle Farm     NA      NA    NA    NA  NA
## 4 Enoggera Reservoir     NA      NA    NA    10  25
## 5          Karawatha     NA      NA    NA    NA  NA
## 6          Larapinta     NA      NA    NA    NA  NA
## 7             Lytton     NA      NA    NA    NA  NA
## 8     Mount Coot-Tha     NA      NA    NA    NA  NA
## 9   Port Of Brisbane     NA      NA    NA    NA  NA

These were excluded.

2.3 Caution

Few cases with ABS flag caution.

## 
## x <lgl>
## # total N=184  valid N=184  mean=0.02  sd=0.15
## 
## Value |   N | Raw % | Valid % | Cum. %
## --------------------------------------
## FALSE | 180 | 97.83 |   97.83 |  97.83
## TRUE  |   4 |  2.17 |    2.17 | 100.00
## <NA>  |   0 |  0.00 |    <NA> |   <NA>

Usually with very small pop numbers.

## # A tibble: 2 x 4
##   caution   mean   min   max
##   <lgl>    <dbl> <int> <int>
## 1 FALSE   6295.     23 22904
## 2 TRUE      38.8    28    49
##      SSC_NAME16 IRSD IRSD_d IRSAD IRSAD_d  IER IER_d  IEO IEO_d URP
## 1        Bulwer 1014      6   996       6 1012     5 1024     7  49
## 2   Cowan Cowan 1014      6   996       6 1012     5 1024     7  28
## 3 England Creek 1004      5   978       5 1063     8  949     3  33
## 4     Kooringal 1014      6   996       6 1012     5 1024     7  45

2.4 ‘Local’ deciles

##  IRSD_d_orig 1 10  2  3  4  5  6  7  8  9
##            1 3  0  0  0  0  0  0  0  0  0
##            2 6  0  0  0  0  0  0  0  0  0
##            3 5  0  0  0  0  0  0  0  0  0
##            4 5  0  0  0  0  0  0  0  0  0
##            5 0  0 13  0  0  0  0  0  0  0
##            6 0  0  6  6  0  0  0  0  0  0
##            7 0  0  0 13 15  0  0  0  0  0
##            8 0  0  0  0  4 14  0  0  0  0
##            9 0  0  0  0  0  4 18 11  0  0
##           10 0 18  0  0  0  0  0  7 18 18
##  IRSAD_d_orig 1 10  2  3  4  5  6  7  8  9
##             1 3  0  0  0  0  0  0  0  0  0
##             2 4  0  0  0  0  0  0  0  0  0
##             3 4  0  0  0  0  0  0  0  0  0
##             4 2  0  0  0  0  0  0  0  0  0
##             5 6  0  2  0  0  0  0  0  0  0
##             6 0  0 11  0  0  0  0  0  0  0
##             7 0  0  6  5  0  0  0  0  0  0
##             8 0  0  0 14  7  0  0  0  0  0
##             9 0  0  0  0 12 18  5  0  0  0
##            10 0 18  0  0  0  0 13 18 18 18
##  IER_d_orig  1 10  2  3  4  5  6 7  8  9
##           1 19  0  1  0  0  0  0 0  0  0
##           2  0  0 18  4  0  0  0 0  0  0
##           3  0  0  0 15  3  0  0 0  0  0
##           4  0  0  0  0 16  2  0 0  0  0
##           5  0  0  0  0  0 16  3 0  0  0
##           6  0  0  0  0  0  0 15 5  0  0
##           7  0  0  0  0  0  0  0 6  0  0
##           8  0  0  0  0  0  0  0 7  5  0
##           9  0  0  0  0  0  0  0 0 13  3
##          10  0 18  0  0  0  0  0 0  0 15
##  IEO_d_orig 1 10  2  3  4  5  6  7  8  9
##           1 4  0  0  0  0  0  0  0  0  0
##           2 3  0  0  0  0  0  0  0  0  0
##           3 3  0  0  0  0  0  0  0  0  0
##           4 9  0  0  0  0  0  0  0  0  0
##           5 0  0  5  0  0  0  0  0  0  0
##           6 0  0  4  0  0  0  0  0  0  0
##           7 0  0 10  7  0  0  0  0  0  0
##           8 0  0  0 12  7  0  0  0  0  0
##           9 0  0  0  0 12 18  3  0  0  0
##          10 0 18  0  0  0  0 15 18 18 18

Example of IRSD_d

3 Dog cost

Top 20 most expensive dogs

dog_breed
Akita
Azawakh
Black Russian Terrier
Canadian Eskimo Dog
Chow Chow
English Bulldog
French Bulldog
French Mastiff
German Shepherd
Hairless Chinese Crested
Irish Wolfhound
Lowchen
Maltese
Pharaoh Hound
Rottweiler
Saint Bernard
Saluki
Samoyed
Tibetan Mastiff
Yorkshire Terrier

4 Dog insurance

4.1 Three major categories

val label frq raw.prc valid.prc cum.prc
Above average <none> 58 10.39 10.39 10.39
Below average <none> 457 81.90 81.90 92.29
Significantly above average <none> 43 7.71 7.71 100.00
NA NA 0 0.00 NA NA

4.2 Individual breeds

Breeds in Above average and Significantly above average categories:

dog_breed cost_compared_to_other_breeds
Hygen Hound Cross Significantly above average
French Bulldog Significantly above average
Yorkshire Terrier Significantly above average
Neopolitan Mastiff Significantly above average
Grand Basset Griffon Vendeen Significantly above average
Formosan Mountain Dog Significantly above average
Newfoundland Significantly above average
Unknown Dog Breed Significantly above average
Australian Bulldog Miniature Significantly above average
Airedale Terrier Significantly above average
Basset Hound Significantly above average
Bullmastiff Significantly above average
Great Dane Significantly above average
Rottweiler Significantly above average
Weimaraner Significantly above average
Bull Terrier Significantly above average
Italian Cane Corso Significantly above average
Australian Bulldog Miniature Cross Significantly above average
Drever Significantly above average
Alaskan Malamute Significantly above average
American Akita Significantly above average
Australian Bulldog Significantly above average
Bedlington Terrier Significantly above average
Boxer Significantly above average
British Bulldog Significantly above average
Dogue De Bordeaux Significantly above average
Drever Cross Significantly above average
Hygen Hound Significantly above average
Irish Setter Significantly above average
Irish Wolfhound Significantly above average
Mastiff Significantly above average
Miniature Doberman Significantly above average
Miniature Pinscher Significantly above average
Pekingese Significantly above average
Poodle – Standard Significantly above average
Shar-Pei Significantly above average
St Bernard Significantly above average
Welsh Corgi – Cardigan Significantly above average
Welsh Corgi – Pembroke Significantly above average
Wire-Haired Terrier Significantly above average
Akita Inu Significantly above average
Alaskan Klee Kai Significantly above average
Bernese Mountain Dog Significantly above average
Welsh Corgi – Pembroke Cross Above average
British Bulldog Cross Above average
Corgi Above average
Weimaraner Cross Above average
Miniature Pinscher Cross Above average
Pinscher Above average
Bull Terrier Cross Above average
Akita Inu Cross Above average
American Bulldog Above average
Australian Bulldog Cross Above average
Bedlington Terrier Cross Above average
Bernese Mountain Dog Cross Above average
Boxer Cross Above average
Chow Chow Above average
Dobermann Above average
Labrador Retriever Above average
Mastiff Cross Above average
Newfoundland Cross Above average
Pekingese Cross Above average
Poodle – Standard Cross Above average
St Bernard Cross Above average
Welsh Corgi – Cardigan Cross Above average
King Charles Spaniel Above average
Polish Lowland Sheepdog Cross Above average
Alaskan Malamute Cross Above average
Irish Wolfhound Cross Above average
Rottweiler Cross Above average
Airedale Terrier Cross Above average
American Akita Cross Above average
American Cocker Spaniel Above average
Basset Hound Cross Above average
Bullmastiff Cross Above average
Dachshund Cross Above average
Doberman Pinscher Above average
Dogue De Bordeaux Cross Above average
English Pointer Above average
French Bulldog Cross Above average
German Short Haired Pointer Cross Above average
Great Dane Cross Above average
Irish Setter Cross Above average
Labrador Above average
Miniature Doberman Cross Above average
Miniature Poodle Above average
Old English Sheepdog Above average
Papillon Cross Above average
Polish Lowland Sheepdog Above average
Rhodesian Ridgeback Cross Above average
Samoyed Above average
Shar-Pei Cross Above average
Rhodesian Ridgeback Above average
Neopolitan Mastiff Cross Above average
Wire-Haired Terrier Cross Above average
Wolfhound Cross Above average
Yorkshire Terrier Cross Above average
Corgi Cross Above average
Wolfhound Above average
Dalmatian Above average
Pinscher Cross Above average

5 Dog ownership in Brisbane